﻿CREATE TABLE [dbo].[dimDate]
(
	[date_Id] [int] IDENTITY(1,1) NOT NULL,
	[real] [smalldatetime] NOT NULL,
	[year] [smallint] NOT NULL,
	[quarter] [tinyint] NOT NULL,
	[month] [tinyint] NOT NULL,
	[dayOfYear] [smallint] NOT NULL,
	[day] [tinyint] NOT NULL,
	[week] [tinyint] NOT NULL,
	[weekDay] [tinyint] NOT NULL,
	[hour] [tinyint] NOT NULL,
	[minute] [tinyint] NOT NULL,
	[serviceLevel] [tinyint] NOT NULL,
	[isHoliday] [bit] NOT NULL,
	[isBusinessDay] [bit] NOT NULL,
	[prev12Months] [bit] NOT NULL,
	[prev6Months] [bit] NOT NULL,
	[prev3Months] [bit] NOT NULL,
	[prev12Weeks] [bit] NOT NULL,
	[prev4Weeks] [bit] NOT NULL,
	[prev14Days] [bit] NOT NULL,
	[prev7Days] [bit] NOT NULL,
	[prev24Hours] [bit] NOT NULL
	CONSTRAINT [PK_dimDate] PRIMARY KEY CLUSTERED 
	(
		[date_Id] ASC
	)
)
